package org.jeecg.modules.sggg.mapper;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.jeecg.modules.sggg.entity.SgSigningRecord;

import java.util.List;
import java.util.Map;

/**
 * @Description: 签约表
 * @Author: jeecg-boot
 * @Date: 2022-10-17
 * @Version: V1.0
 */
public interface SgSigningRecordMapper extends BaseMapper<SgSigningRecord> {

    IPage<SgSigningRecord> pageList(IPage<SgSigningRecord> page, String memberName, String phone, String idCard, List<String> responsibleAgencies,String sysOrgCode, String isXj, String orgCode, String roleCode, String userId);

    List<SgSigningRecord> getSigningRecord(String memberId);


//    IPage<SgSigningRecord> renewalListTo(IPage<SgSigningRecord> page, SgSigningRecord signingRecord, String userId);
    /*本年度三高签约统计*/
    List<Map<String,Object>> yearSigning(String orgCode, String createTime, String updateTime);

    /*本月三高签约统计*/
    List<Map<String,Object>> monthlySigning(String orgCode, String createTime, String updateTime);

    /*血压、血糖、血脂签约人数*/
    List<Map<String,Object>> threeHightSignNumber(String orgCode,List<String> responsibleAgencies);

    List<SgSigningRecord> getSigningRecordByMid(String memberId);

    IPage<SgSigningRecord> renewalListTo(IPage<SgSigningRecord> page, String memberName, Integer num, List<String> responsibleAgencies,String orgCode, String userId);
}
